package com.hydl.power.mapper;

import com.hydl.power.pojo.ElectricityBill;
import com.hydl.power.pojo.PowerConsume;
import com.hydl.power.pojo.TemperatureData;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TemperatureDataMapper {


    List<TemperatureData> getTemperatureDataLine(String deviceId,String time,String tableName);


    List<PowerConsume> listByMonth(@Param("startTime") String startTime, @Param("areaId") String areaId, @Param("projectId") String projectId, @Param("powerRoomId") String powerRoomId, @Param("tableName") String tableName,
                                    String endTime);

    List<PowerConsume> dayPower(@Param("createTime") String createTime, @Param("areaId") String areaId, @Param("projectId") String projectId, @Param("powerRoomId") String powerRoomId,@Param("tableName") String tableName);

    List<PowerConsume> listByYear(@Param("startTime") String startTime, @Param("areaId") String areaId, @Param("projectId") String projectId, @Param("powerRoomId") String powerRoomId,@Param("tableName") String tableName);

    List<PowerConsume> listByWeek(@Param("startTime") String startTime,@Param("endTime") String endTime, @Param("areaId") String areaId, @Param("projectId") String projectId, @Param("powerRoomId") String powerRoomId,@Param("tableName") String tableName);

    TemperatureData queryTemperatureData (String tableName,String deviceId);

    int insertTemperatureData(TemperatureData temperatureData);

    List<TemperatureData> queryeTemperature(String tableName,String startTime);

    TemperatureData queryeTemperatureByDeviceId(String tableName,String sn);

    String queryePowereOneDay(String tableName,String projectId);

    String queryePowereOneMonth(String tableName,String projectId);

    String queryePowereOneYear(String tableName,String projectId);

    List<ElectricityBill> getMonthElectricityBill(String time, String temperatureDataTableName);

    List<TemperatureData> getPowerDataBySerialNumber(String serialNumber, String time, String temperatureDataTableName);

    List<PowerConsume> getPowerDataByMonth(String startTime, String endTime, String projectId, String tableName);
}
